# coding: utf-8
from . import db, BaseModel


class Experiment(db.Model):
    __tablename__ = 'experiment'

    auto_id = db.Column(db.Integer, primary_key=True)
    experiment_id = db.Column(db.BigInteger, index=True, info='实验编号')
    experiment_name = db.Column(db.String(255), info='实验名称')
    classroom = db.Column(db.String(255), info='实验教室')
    lesson_id = db.Column(db.BigInteger, info='参与班级')
    teacher_id = db.Column(db.BigInteger, info='负责教师')
    description = db.Column(db.String(255), info='描述')
    start_time = db.Column(db.DateTime)
    end_time = db.Column(db.DateTime)
    is_delete = db.Column(db.Integer, server_default=db.FetchedValue())
    update_time = db.Column(db.DateTime, server_default=db.FetchedValue())
    create_time = db.Column(db.DateTime, server_default=db.FetchedValue())
